Data Sources and Targets Reference

The following is a list of data sources supported in Model Pro. For information about how to configure data sources in the Admin tool, click here.

Source

 

Direct Query

Target

Compatible with Pulse

Configuration

Access

 

 

 

Local file upload, or pointer to a shared file on a network drive

Amazon Athena

 

Requires setup and configuration in Administration

Amazon S3

   

Requires setup and configuration in Administration

Apache Drill

Requires setup and configuration in Administration

Apache Hive

Requires setup and configuration in Administration

Apache Presto

Requires setup and configuration in Administration

AWS Buckets

 

 

 

Requires setup and configuration in Administration

Azure Blob

 

 

 

Requires setup and configuration in Administration

Azure SSAS Tabular

 

 

 

Requires setup and configuration in Administration

Azure Synapse

 

Requires setup and configuration in Administration

DB2

Requires setup and configuration in Administration

Exasol

Requires setup and configuration in Administration

Exasol

Requires setup and configuration in Administration

Excel

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

Facebook

 

 

 

Requires setup and configuration in Administration

Firebird

 

Requires setup and configuration in Administration

Glue (Datavard)

 

Requires setup and configuration in Administration

Google Analytics

     

Requires setup and configuration in Administration

Google BigQuery

 

Requires setup and configuration in Administration

Google Sheets

 

 

 

ID or URL address

Greenplum (Pivotal)

Requires setup and configuration in Administration

Impala

Requires setup and configuration in Administration

In Memory

Requires setup and configuration in Administration

JSON

 

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

MariaDB

Requires setup and configuration in Administration

memSQL

Requires setup and configuration in Administration

Mongo BI CX

 

Requires setup and configuration in Administration

Multi Files

 

 

 

 

Enter the shared folder path and the files to include in the upload. Each file must have the same structure (columns).

Note: this data source is not available in the Community Edition.

MySQL

Requires setup and configuration in Administration

Netezza

Requires setup and configuration in Administration

OData

     

Requires configuration in the client (add the node to the Data Flow and enter the OData Service URL in the Properties panel)

ODBC

     

Requires setup and configuration in Administration - click here for details.

Oracle

Requires setup and configuration in Administration

PostgreSQL

Requires setup and configuration in Administration

Pyramid Queries

N/A

N/A

 

 

Python as a source

N/A

N/A

   

R as a source

N/A

N/A

   

Redshift

 

Requires setup and configuration in Administration

RSS

 

 

 

Add the Feed URL in the Properties panel

SalesForce

   

 

Requires setup and configuration in Administration

SAP HANA

Requires setup and configuration in Administration

SAS Data Set

 

 

 

Local file upload, or pointer to a shared .sas7bdat file on a network drive, or URL Address

SharePoint Lists

 

 

Requires setup and configuration in Administration

Snowflake

 

Requires setup and configuration in Administration

SQL Server

Requires setup and configuration in Administration

SQL Server Azure

 

Requires setup and configuration in Administration

Sybase / SAP

Requires setup and configuration in Administration - select Shared Folder property

Teradata

Requires setup and configuration in Administration

Text

 

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address. Select the encoding of the file. Supports both Fixed Width Column files, and Delimited files. Custom delimiters are supported - type the delimiter in the Delimiters window in the Properties panel.

Twitter

 

 

 

Requires setup and configuration in Administration

Vertica

Requires setup and configuration in Administration

XML

 

 

 

Local file upload, or pointer to a shared file on a network drive, or URL Address

Note: If users have rights, they can setup configurable data sources themselves directly from inside the data modeling tools.

Pass-through Direct Query

Pass-through datasources can be natively queried by Pyramid with direct queries. This means that the data does not need to be pre-processed or copied by Pyramid (or any other technology) before it can be queried by users.

Note: MS Analysis Services (OLAP and Tabular) can be directly queried using their existing cubes and tabular models.

Data Targets

'Targets' in data preparation allows Pyramid to mash up data and WRITE the resulting database to the targeted technology and designated server. Given that Pyramid can write to a variety of data stacks, the targeting options give users a wide variety of options on where to build intermediate models and how to correct issues with their data before they start the analysis process.

Pulse

A number of datasources are compatible with Pulse. When connecting to a Pulse datasource, you may opt to directly query the datasource, or you may add select or multi-select nodes to perform data streaming.

Note: click here to learn more about Pulse, including how to configure Pulse nodes in the Admin console.